inherited frmQueryChoiceProduct: TfrmQueryChoiceProduct
  Left = 342
  Top = 139
  Caption = #36873#25321#36135#21697
  ClientHeight = 536
  ClientWidth = 794
  ExplicitWidth = 800
  ExplicitHeight = 561
  PixelsPerInch = 96
  TextHeight = 12
  inherited pnlBottom: TPanel
    Top = 481
    Width = 794
    TabOrder = 2
    ExplicitTop = 481
    ExplicitWidth = 794
    inherited btnOK: TcxButton
      Left = 612
      Top = 15
      ModalResult = 0
      TabOrder = 3
      OnClick = btnOKClick
      ExplicitLeft = 612
      ExplicitTop = 15
    end
    inherited btnCancel: TcxButton
      Left = 702
      Top = 15
      TabOrder = 4
      ExplicitLeft = 702
      ExplicitTop = 15
    end
    object btnAppendAll: TcxButton
      Left = 332
      Top = 15
      Width = 75
      Height = 25
      Caption = #20840#37096#28155#21152
      OptionsImage.Glyph.SourceDPI = 96
      OptionsImage.Glyph.Data = {
        424D360400000000000036000000280000001000000010000000010020000000
        000000000000C40E0000C40E00000000000000000000FF00FF00FF00FF00FF00
        FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00FF00FF00FF00FF00808080FF808080FF808080FF808080FFFF00
        FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00808080FFFF00
        FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00FF00FF00008000FF008000FF008000FFFF00FF00808080FFFF00
        FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00FF00FF00008000FF008000FF008000FFFF00FF00808080FF8080
        80FFFF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00008000FF008000FFFF00FF00008000FF008000FFFF00FF008080
        80FFFF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00008000FF008000FFFF00FF00008000FF008000FFFF00FF008080
        80FFFF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00008000FF008000FFFF00FF00008000FF008000FFFF00FF008080
        80FF808080FFFF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00008000FF008000FFFF00FF00808080FFFF00FF00008000FF008000FFFF00
        FF00808080FFFF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00008000FF008000FFFF00FF00808080FFFF00FF00008000FF008000FFFF00
        FF00808080FFFF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00008000FF008000FFFF00FF00808080FFFF00FF00008000FF008000FFFF00
        FF00808080FF808080FFFF00FF00FF00FF00FF00FF00FF00FF00FF00FF000080
        00FF008000FFFF00FF00808080FFFF00FF00FF00FF00FF00FF00008000FF0080
        00FFFF00FF00808080FFFF00FF00FF00FF00FF00FF00FF00FF00FF00FF000080
        00FF008000FFFF00FF00FF00FF00FF00FF00FF00FF00FF00FF00008000FF0080
        00FFFF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00
        FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00FF00}
      TabOrder = 2
      Visible = False
      OnClick = btnAppendAllClick
    end
    object btnSelAll: TcxButton
      Left = 9
      Top = 15
      Width = 75
      Height = 25
      Caption = #20840#36873
      LookAndFeel.Kind = lfUltraFlat
      TabOrder = 0
      OnClick = btnSelAllClick
    end
    object btnEmpty: TcxButton
      Left = 93
      Top = 15
      Width = 75
      Height = 25
      Caption = #28165#31354
      LookAndFeel.Kind = lfUltraFlat
      TabOrder = 1
      OnClick = btnEmptyClick
    end
    object cxLabel1: TcxLabel
      Left = 180
      Top = 20
      Caption = #21452#20987#36135#21697#21363#21487#36873#25321#28155#21152#36135#21697
      ParentFont = False
      Style.Font.Charset = GB2312_CHARSET
      Style.Font.Color = clBlue
      Style.Font.Height = -12
      Style.Font.Name = #23435#20307
      Style.Font.Style = []
      Style.IsFontAssigned = True
    end
  end
  object cxGroupBox1: TcxGroupBox
    Left = 8
    Top = 7
    Anchors = [akLeft, akTop, akRight]
    Caption = #36807#28388#26465#20214
    TabOrder = 0
    DesignSize = (
      778
      219)
    Height = 219
    Width = 778
    object chkDynFind: TcxCheckBox
      Left = 70
      Top = -4
      Caption = #21160#24577#26597#35810
      TabOrder = 0
    end
    object cxLabel3: TcxLabel
      Left = 23
      Top = 26
      Caption = #32534#30721
      Transparent = True
    end
    object cxLabel4: TcxLabel
      Left = 23
      Top = 54
      Caption = #21517#31216
      Transparent = True
    end
    object cxLabel5: TcxLabel
      Left = 23
      Top = 82
      Caption = #35268#26684
      Transparent = True
    end
    object cxLabel6: TcxLabel
      Left = 23
      Top = 111
      Caption = #31867#21035
      Transparent = True
    end
    object chkLately: TcxCheckBox
      Left = 246
      Top = 23
      Caption = #26174#31034#26368#36817#36135#21697
      TabOrder = 4
      Transparent = True
      OnClick = chkLatelyClick
    end
    object chkHappen: TcxCheckBox
      Left = 246
      Top = 52
      Caption = #26174#31034#24403#21069#24448#26469#21333#20301#26377#20379#38144#35760#24405#30340#36135#21697
      TabOrder = 8
      Transparent = True
    end
    object chkTraderProduct: TcxCheckBox
      Left = 246
      Top = 80
      Caption = #26174#31034#24403#21069#24448#26469#21333#20301#30340#20379#38144#36135#21697
      TabOrder = 12
      Transparent = True
    end
    object chkDepotQty: TcxCheckBox
      Left = 246
      Top = 108
      Caption = #26174#31034#26377#24211#23384#36135#21697
      TabOrder = 14
      Transparent = True
    end
    object lblDepot: TcxLabel
      Left = 369
      Top = 110
      Caption = #24403#21069#20179#24211': '#25152#26377#20179#24211
      Transparent = True
    end
    object cxGroupBox2: TcxGroupBox
      Left = 250
      Top = 134
      Caption = #23384#36135#31867#22411
      TabOrder = 18
      Height = 73
      Width = 230
      object rbAll: TcxRadioButton
        Left = 23
        Top = 18
        Width = 104
        Height = 17
        Caption = #20840#37096
        Checked = True
        TabOrder = 0
        TabStop = True
        OnClick = rbAllClick
        Transparent = True
      end
      object rbDepot: TcxRadioButton
        Left = 23
        Top = 42
        Width = 104
        Height = 17
        Caption = #23384#36135#31867
        TabOrder = 2
        OnClick = rbAllClick
        Transparent = True
      end
      object rbNotDepot: TcxRadioButton
        Left = 121
        Top = 18
        Width = 105
        Height = 20
        Caption = #38750#23384#36135#31867'/'#26381#21153
        TabOrder = 1
        OnClick = rbAllClick
        Transparent = True
      end
      object rbDisc: TcxRadioButton
        Left = 121
        Top = 42
        Width = 105
        Height = 17
        Caption = #25240#25187
        TabOrder = 3
        OnClick = rbAllClick
        Transparent = True
      end
    end
    object edtProductCode: TcxTextEdit
      Left = 55
      Top = 25
      Properties.OnChange = edtProductCodePropertiesChange
      TabOrder = 5
      OnKeyPress = edtProductCodeKeyPress
      Width = 180
    end
    object edtProductName: TcxTextEdit
      Left = 55
      Top = 53
      Properties.OnChange = edtProductCodePropertiesChange
      TabOrder = 9
      OnKeyPress = edtProductCodeKeyPress
      Width = 180
    end
    object edtProductSpecs: TcxTextEdit
      Left = 55
      Top = 80
      TabOrder = 11
      OnKeyPress = edtProductCodeKeyPress
      Width = 180
    end
    object edtProductType: TdxLookupTreeView
      Left = 55
      Top = 109
      Width = 180
      Height = 20
      CanSelectParents = True
      ParentColor = False
      TabOrder = 15
      TabStop = True
      Text = ''
      TreeViewColor = clWindow
      TreeViewCursor = crDefault
      TreeViewFont.Charset = DEFAULT_CHARSET
      TreeViewFont.Color = clWindowText
      TreeViewFont.Height = -11
      TreeViewFont.Name = 'MS Sans Serif'
      TreeViewFont.Style = []
      TreeViewIndent = 19
      TreeViewReadOnly = False
      TreeViewShowButtons = True
      TreeViewShowHint = False
      TreeViewShowLines = True
      TreeViewShowRoot = True
      TreeViewSortType = stNone
      OnClick = chkLatelyClick
      DisplayField = 'name'
      DividedChar = '.'
      ImageIndexField = 'imgindex'
      ListSource = dsProductType
      KeyField = 'id'
      ListField = 'name'
      Options = [trDBCanDelete, trDBConfirmDelete, trCanDBNavigate, trSmartRecordCopy, trCheckHasChildren]
      ParentField = 'pid'
      RootValue = Null
      TextStyle = tvtsShort
      Alignment = taLeftJustify
    end
    object lblDepotBook: TcxLabel
      Left = 490
      Top = 21
      Caption = #20179#24211
      Transparent = True
    end
    object grdBook: TcxGrid
      Left = 491
      Top = 41
      Width = 274
      Height = 166
      Anchors = [akLeft, akTop, akRight, akBottom]
      TabOrder = 7
      object grdBookDBTableView1: TcxGridDBTableView
        Navigator.Buttons.CustomButtons = <>
        DataController.DataSource = dsBook
        DataController.Summary.DefaultGroupSummaryItems = <>
        DataController.Summary.FooterSummaryItems = <>
        DataController.Summary.SummaryGroups = <>
        OptionsData.CancelOnExit = False
        OptionsData.Deleting = False
        OptionsData.DeletingConfirmation = False
        OptionsData.Editing = False
        OptionsData.Inserting = False
        OptionsView.ColumnAutoWidth = True
        OptionsView.GroupByBox = False
        Styles.Background = MainDM.bslBackGroup
        Styles.ContentEven = MainDM.bsEven
        Styles.ContentOdd = MainDM.bsOdd
        Styles.Footer = MainDM.bsTitle
        Styles.Header = MainDM.bsTitle
        Styles.Selection = MainDM.bsSelect
        object grdBookDBTableView1name: TcxGridDBColumn
          DataBinding.FieldName = 'name'
          HeaderAlignmentHorz = taCenter
          Width = 118
        end
        object grdBookDBTableView1quantity: TcxGridDBColumn
          DataBinding.FieldName = 'quantity'
          HeaderAlignmentHorz = taCenter
          Width = 79
        end
        object grdBookDBTableView1factqty: TcxGridDBColumn
          DataBinding.FieldName = 'factqty'
          HeaderAlignmentHorz = taCenter
          Width = 78
        end
      end
      object grdBookLevel1: TcxGridLevel
        GridView = grdBookDBTableView1
      end
    end
    object edtDepot: TcxDBLookupComboBox
      Tag = 7
      Left = 525
      Top = 17
      DataBinding.DataField = 'depotid'
      DataBinding.DataSource = dsDepot
      Properties.ListColumns = <>
      TabOrder = 2
      Width = 145
    end
    object chkShowPic: TcxCheckBox
      Left = 226
      Top = -4
      Caption = #26174#31034#36135#21697#22270#29255
      TabOrder = 1
    end
    object chkFilterCaseIns: TcxCheckBox
      Left = 140
      Top = -4
      Caption = #24573#30053#22823#23567#20889
      Properties.ImmediatePost = True
      Properties.OnValidate = chkFilterCaseInsPropertiesValidate
      State = cbsChecked
      TabOrder = 19
    end
  end
  object grdProduct: TcxGrid
    Left = 8
    Top = 235
    Width = 775
    Height = 244
    Anchors = [akLeft, akTop, akRight, akBottom]
    TabOrder = 1
    object grdProductDBTableView1: TcxGridDBTableView
      OnDblClick = grdProductDBTableView1DblClick
      Navigator.Buttons.CustomButtons = <>
      OnFocusedRecordChanged = grdProductDBTableView1FocusedRecordChanged
      DataController.DataSource = dsProduct
      DataController.Summary.DefaultGroupSummaryItems = <>
      DataController.Summary.FooterSummaryItems = <>
      DataController.Summary.SummaryGroups = <>
      OptionsBehavior.FocusCellOnTab = True
      OptionsBehavior.GoToNextCellOnEnter = True
      OptionsBehavior.FocusCellOnCycle = True
      OptionsData.CancelOnExit = False
      OptionsData.Deleting = False
      OptionsData.DeletingConfirmation = False
      OptionsData.Inserting = False
      OptionsView.ColumnAutoWidth = True
      OptionsView.GroupByBox = False
      Styles.Background = MainDM.bslBackGroup
      Styles.ContentEven = MainDM.bsEven
      Styles.ContentOdd = MainDM.bsOdd
      Styles.Footer = MainDM.bsTitle
      Styles.Header = MainDM.bsTitle
      Styles.Selection = MainDM.bsSelect
      object grdProductTag: TcxGridDBColumn
        DataBinding.FieldName = 'tag'
        HeaderAlignmentHorz = taCenter
      end
      object grdProductproductcode: TcxGridDBColumn
        DataBinding.FieldName = 'productcode'
        HeaderAlignmentHorz = taCenter
        Options.Editing = False
        Width = 69
      end
      object grdProductDBTableView1productname: TcxGridDBColumn
        DataBinding.FieldName = 'productname'
        HeaderAlignmentHorz = taCenter
        Options.Editing = False
        Width = 100
      end
      object grdProductDBTableView1spec: TcxGridDBColumn
        DataBinding.FieldName = 'spec'
        HeaderAlignmentHorz = taCenter
        Options.Editing = False
        Width = 87
      end
      object grdProductDBTableView1unitname: TcxGridDBColumn
        DataBinding.FieldName = 'unitname'
        HeaderAlignmentHorz = taCenter
        Options.Editing = False
        Width = 52
      end
      object grdProductDBTableView1price1: TcxGridDBColumn
        DataBinding.FieldName = 'price1'
        HeaderAlignmentHorz = taCenter
        Options.Editing = False
        Width = 35
      end
      object grdProductDBTableView1price2: TcxGridDBColumn
        DataBinding.FieldName = 'price2'
        HeaderAlignmentHorz = taCenter
        Options.Editing = False
        Width = 33
      end
      object grdProductDBTableView1price3: TcxGridDBColumn
        DataBinding.FieldName = 'price3'
        HeaderAlignmentHorz = taCenter
        Options.Editing = False
        Width = 34
      end
      object grdProductDBTableView1price4: TcxGridDBColumn
        DataBinding.FieldName = 'price4'
        HeaderAlignmentHorz = taCenter
        Options.Editing = False
        Width = 33
      end
      object grdProductDBTableView1price5: TcxGridDBColumn
        DataBinding.FieldName = 'price5'
        HeaderAlignmentHorz = taCenter
        Options.Editing = False
        Width = 35
      end
    end
    object grdProductLevel1: TcxGridLevel
      GridView = grdProductDBTableView1
    end
  end
  object qryProduct: TUniQuery
    Connection = MainDM.UniConn
    SQL.Strings = (
      ''
      'select distinct p.p_id, p.code productcode, p.name productname, '
      
        '     p.spec, p.speed, u.unitname, u.price1, u.price2, u.price3, ' +
        'u.price4, u.price5, '
      
        '     convert(int, NULL) as depotid, p.quantity, p.factqty, p.Kin' +
        'd, p.calccost, '
      '     p.custom1, p.custom2, p.custom3, p.custom4, p.custom5, '
      '     p.custom6, p.custom7, p.custom8, p.custom9, p.custom10 '
      '     from td_product p'
      
        '     left join td_unitprice u on(p.p_id=u.productid and baseunit' +
        '=1)'
      '     left join td_producttype s on p.productTypeID=s.ID'
      '     where p.pause = 0')
    CachedUpdates = True
    Options.SetFieldsReadOnly = False
    Options.RequiredFields = False
    Options.QueryRecCount = True
    AfterScroll = qryProductAfterScroll
    Left = 288
    Top = 278
    object qryProducttag: TBooleanField
      DisplayLabel = #36873#25321
      FieldName = 'tag'
    end
    object qryProductp_id: TIntegerField
      FieldName = 'p_id'
    end
    object qryProductproductcode: TStringField
      DisplayLabel = #36135#21697#32534#30721
      FieldName = 'productcode'
      Size = 30
    end
    object qryProductproductname: TWideStringField
      DisplayLabel = #21517#31216
      FieldName = 'productname'
      Size = 60
    end
    object qryProductspec: TWideStringField
      DisplayLabel = #35268#26684
      FieldName = 'spec'
      Size = 60
    end
    object qryProductunitname: TWideStringField
      DisplayLabel = #22522#26412#21333#20301
      FieldName = 'unitname'
      Size = 30
    end
    object qryProductprice1: TFloatField
      DisplayLabel = #19968#32423#25209#21457#20215
      FieldName = 'price1'
    end
    object qryProductprice2: TFloatField
      DisplayLabel = #20108#32423#25209#21457#20215
      FieldName = 'price2'
    end
    object qryProductprice3: TFloatField
      DisplayLabel = #19977#32423#25209#21457#20215
      FieldName = 'price3'
    end
    object qryProductdepotid: TIntegerField
      FieldName = 'depotid'
    end
    object qryProductprice4: TFloatField
      DisplayLabel = #22235#32423#25209#21457#20215
      FieldName = 'price4'
    end
    object qryProductprice5: TFloatField
      DisplayLabel = #20116#32423#25209#21457#20215
      FieldName = 'price5'
    end
    object qryProductquantity: TFloatField
      FieldName = 'quantity'
    end
    object qryProductfactqty: TFloatField
      FieldName = 'factqty'
    end
    object qryProductKind: TIntegerField
      FieldName = 'Kind'
    end
    object qryProductcalccost: TByteField
      FieldName = 'calccost'
    end
    object qryProductcustom1: TStringField
      FieldName = 'custom1'
      Size = 100
    end
    object qryProductcustom2: TStringField
      FieldName = 'custom2'
      Size = 100
    end
    object qryProductcustom3: TStringField
      FieldName = 'custom3'
      Size = 100
    end
    object qryProductcustom4: TStringField
      FieldName = 'custom4'
      Size = 100
    end
    object qryProductcustom5: TStringField
      FieldName = 'custom5'
      Size = 100
    end
    object qryProductcustom6: TStringField
      FieldName = 'custom6'
      Size = 100
    end
    object qryProductcustom7: TStringField
      FieldName = 'custom7'
      Size = 100
    end
    object qryProductcustom8: TStringField
      FieldName = 'custom8'
      Size = 100
    end
    object qryProductcustom9: TStringField
      FieldName = 'custom9'
      Size = 100
    end
    object qryProductcustom10: TStringField
      FieldName = 'custom10'
      Size = 100
    end
  end
  object qryBook: TUniQuery
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select b.depotid, d.name, b.quantity, b.factqty from tt_book b'
      'left join td_depot d on b.depotid=d.depotid '
      
        'where b.productid=:productid and d.pause=0 and d.filid=:filid  a' +
        'nd (b.depotid=:depotid or 0=:depotid1)')
    CachedUpdates = True
    Options.RequiredFields = False
    Options.QueryRecCount = True
    AfterScroll = qryBookAfterScroll
    Left = 284
    Top = 358
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'productid'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'filid'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'depotid'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'depotid1'
        Value = nil
      end>
    object qryBookdepotid: TIntegerField
      FieldName = 'depotid'
    end
    object qryBookname: TWideStringField
      DisplayLabel = #20179#24211
      FieldName = 'name'
      Size = 60
    end
    object qryBookquantity: TFloatField
      DisplayLabel = #24080#38754#24211#23384
      FieldName = 'quantity'
    end
    object qryBookfactqty: TFloatField
      DisplayLabel = #23454#38469#24211#23384
      FieldName = 'factqty'
    end
  end
  object dsProduct: TDataSource
    DataSet = qryProduct
    Left = 344
    Top = 282
  end
  object dsBook: TDataSource
    DataSet = qryBook
    Left = 340
    Top = 358
  end
  object qryDepot: TUniQuery
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select * from td_depot where 1 =2 order by depotid')
    CachedUpdates = True
    Options.SetFieldsReadOnly = False
    Options.RequiredFields = False
    Options.QueryRecCount = True
    Left = 680
    Top = 230
  end
  object dsDepot: TDataSource
    DataSet = qryDepot
    Left = 756
    Top = 235
  end
  object qryProductType: TUniQuery
    Connection = MainDM.UniConn
    SQL.Strings = (
      
        'select -1 id,'#39'<'#20840#37096'>'#39' name,'#39#39' subcode,'#39#39' code,null pid,cast(0.00 a' +
        's decimal) taxrate,cast(0 as bit) deftaxrate,cast(0 as bit) paus' +
        'e,0 imgindex'
      'union all'
      'select * from td_producttype order by pid, subcode')
    CachedUpdates = True
    Options.SetFieldsReadOnly = False
    Options.RequiredFields = False
    Options.QueryRecCount = True
    Left = 120
    Top = 123
    object qryProductTypeid: TIntegerField
      FieldName = 'id'
    end
    object qryProductTypename: TWideStringField
      FieldName = 'name'
      Size = 60
    end
    object qryProductTypesubcode: TWideStringField
      FieldName = 'subcode'
      Size = 30
    end
    object qryProductTypecode: TWideStringField
      FieldName = 'code'
      Size = 30
    end
    object qryProductTypepid: TIntegerField
      FieldName = 'pid'
    end
    object qryProductTypedeftaxrate: TBooleanField
      FieldName = 'deftaxrate'
    end
    object qryProductTypepause: TBooleanField
      FieldName = 'pause'
    end
    object qryProductTypeimgindex: TIntegerField
      FieldName = 'imgindex'
    end
    object qryProductTypetaxrate: TFloatField
      FieldName = 'taxrate'
    end
  end
  object dsProductType: TDataSource
    DataSet = qryProductType
    Left = 196
    Top = 135
  end
end
